Description |
1 online resource (xv, 277 pages) : illustrations |
|
text file |
Contents |
1. Assessment -- A Simple Example -- Assessing Possible Gains -- 2. Sanity Checks -- Statistics and Data Skewness -- Indexing Review -- Parsing and Bind Variables -- Bulk Operations -- Transaction Management -- 3. User Functions and Views -- User-Defined Functions -- Views -- 4. Testing Framework -- Generating Test Data -- Comparing Alternative Versions -- 5. Statement Refactoring -- Execution Plans and Optimizer Directives -- Analyzing a Slow Query -- Refactoring the Query Core -- Rebuilding the Initial Query -- 6. Task Refactoring -- The SQL Mindset -- Restructuring the Code -- 7. Refactoring Flows and Databases -- Reorganizing Processing -- Shaking Foundations -- 8. How It Works: Refactoring in Practice -- Can you Look at the Database? -- Queries of Death -- All These Fast Queries -- No Obvious Very Wrong Query -- Time to Conclude -- A. Scripts and Sample Programs -- B. Tools. |
Summary |
What can you do when database performance doesn't meet expectations? This book offers methods for refactoring (or changing) SQL code to improve performance without altering a database application's purpose -- and helps you do it on a shoestring budget. This isn't a rehash of theory, but a tested set of options for making code modifications to dramatically improve the way your applications function. |
Subject |
SQL (Computer program language)
|
|
Database management.
|
|
SQL (Langage de programmation) |
|
Bases de données -- Gestion. |
|
SQL (Computer program language) |
|
Database management. |
|
Database management |
|
SQL (Computer program language) |
Indexed Term |
Databases |
Added Author |
L'Hermite, Pascal.
|
Other Form: |
9780596514976 |
ISBN |
9780596514976 |
|
0596514972 |
|
9780596551773 (electronic bk.) |
|
0596551770 (electronic bk.) |
|
9780596154950 (electronic bk.) |
|
059615495X (electronic bk.) |
Standard No. |
9780596514976 |
|